-- =============================================
-- Procedure: GetAllRoles
-- Purpose:	Gets all roles
-- Author: Dale McFarlane
-- Created: 2013-1-20
-- Modification History
-- Modified By	Modification Date	Reason
-- =====================================================================================
--  
-- =====================================================================================

-- EXEC 

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[GetAllRoles]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.[GetAllRoles]
END
GO

CREATE PROCEDURE GetAllRoles

AS
BEGIN
	SELECT 
	*
	FROM dbo.[role] r

END
GO